Pt-online-change-ddl (online ddl)

Mysql > desc online_ddl;+-+-+ |

2022-06-01 Database 我要分享

How to safely clear the slow query log slowlog online

This article will explain in detail how to safely empty the slow query log slowlog online. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article. Mysql > show variables lik

2022-05-31 Database 我要分享

The procedure and principle of online handover of MySQL High availability Scheme MHA

In daily work, you will encounter the following scenarios, such as mysql database upgrade, master server hardware upgrade, etc., when you need to switch the write operation to another server, so how to switch online? At the same time, the switching process is required to be short, and the impact on the business is relatively small. MHA provides

2022-06-01 Database 我要分享

What are the differences between MySQL ONLINE DDL and PT-ONLINE-SCHEMA-CHANGE

This article mainly introduces "what is the difference between MySQL ONLINE DDL and PT-ONLINE-SCHEMA-CHANGE". In daily operation, I believe that many people use MySQL ONLINE DDL and PT-ONLINE-SCHE.

2022-05-31 Database 我要分享

How to correctly and safely clear the online slow query log slow log in mysql

This article will explain in detail how to safely empty the online slow query log slow log in mysql. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article. 1, see the slow

2022-05-31 Database 我要分享

Bug of pt-online-schema-change

Mysql5.6 and mysql5.7 have greatly enhanced the function of online DDL, but there is still a situation that the master library executes DDL and the slave library has a large delay, so the current production environment is still through pt-online-schema-change tools.

2022-06-01 Database 我要分享

Mysql- server-extended configuration

Mysql- server-extended configuration extended configuration max_connections allows the maximum number of connections, default 100, maximum 16384. This is adjusted according to performance. If a 3000 connection will result in insufficient resources for mysql, give it to 3000. Because give more.

2022-06-02 Servers 我要分享

Use Redis to record user online status

Hash table (HashTable) is a data structure that implements key-value (Key-Value) mapping. According to Key, you can quickly find Value. And, no matter how many key-value pairs there are, the query time remains the same. Python's dictionary is based on ha.

2022-06-01 Database 我要分享

Depth | the storage cost of real-time history database is amazing, how to break it?

Author: Hu Dao Ali Yun Operation and maintenance expert Zhouji Ali Yun solution architect Real-time History Library requirement background in today's digital age, with the rapid development of business, the amount of data generated every day will be an astonishing amount. The cost of database storage will become higher and higher, and the usual practice is for historical data.

2022-06-01 Database 我要分享

What are the knowledge points of MySQL Online DDL?

This article mainly introduces "what are the knowledge points of MySQL Online DDL". In the daily operation, I believe that many people have doubts about the knowledge points of MySQL Online DDL. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods.

2022-05-31 Database 我要分享

How to operate cross-library Join

How to operate cross-library Join, in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method. Abstract: enterprises choose to split their online business databases, or choose different database types to

2022-05-31 Servers 我要分享

A brief introduction to the related knowledge of MySQL5.7 online DDL

This article mainly introduces MySQL5.7 online DDL related knowledge, the content of the article is carefully selected and edited by the author, with a certain pertinence, for everyone's reference significance is still relatively great, the following with the author to understand the MySQL5.7 online DDL related knowledge. 1 、 M

2022-06-01 Database 我要分享

Open online course _ my understanding of Oracle addition, deletion, modification and query is different from yours.

Hello, Beijing Shennao invites you to attend a webinar using WebEx. Topic: open online course _ my understanding of Oracle addition, deletion, modification and search is different from yours. Host: Beijing Shennao date and time: July 1, 2014

2022-06-01 Database 我要分享

InnoDB Online DDL continued

The limitation of Online DDL is mentioned in "InnoDB Online DDL glance". In the master-slave replication environment, if it takes a long time to change the ALTER TABLE to a large table on the master database, the process is generally better than that in the slave database.

2022-06-01 Database 我要分享

Project practice: search for comparative testing tools

Search for comparison testing tool catalog 1. Introduction to the tool. 12. Design ideas. 13. The utility of the tool. 34. Tool integration extension. 61. Tool introduction: due to the company's search service and underlying index creation and maintenance, maintenance by colleagues in the infrastructure department, business access

2022-06-03 Internet Technology 我要分享

[MySQL] Database Middleware-- ProxySQL+MGR

[root@wallet01 ~] # mysql-uroot-p < addition_to_sys.sql Enter password: [root@wallet01 ~] # mysql-ur

2022-06-01 Database 我要分享

Optimization method of NoSql Application in ElasticSearch

Most people do not understand the knowledge points of this article "the method of NoSql Application Optimization in ElasticSearch", so the editor summarizes the following contents, detailed contents, clear steps, and has a certain reference value. I hope you can gain something after reading this article.

2022-05-31 Internet Technology 我要分享

Example Analysis of online problem and Optimization of slow Log in MySQL

This article will explain in detail the example analysis of online problems and optimization of slow logs in MySQL. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article. MySQL slow log (slow log) is MyS

2022-05-31 Database 我要分享

Data files are not recognized / locked by ORA-01157 and ORA-01110

The same error was reported in production before. The user queried the data in the client table and reported the following error: Errors in file / oratrace/xxx/diag/rdbms/xxx/xxx2/trace/xxx2_dbw0_845

2022-06-01 Database 我要分享

How to circumvent RDS performance issues in terms of design and specification?

[this article is from neo.Wang, author of the Cloud Community.] in start-up Internet companies, the only thing developers think about all day is to "do it." And when the company's business volume gradually increased, or even increased several times, the initial procedural problems were exposed one by one.

2022-06-01 Database 我要分享